-- @owner: @zou_jialiang050
-- @date: 2023-01-09
-- @testpoint: drop type字段后,创建引用type的函数

--step1:创建type expect:成功
drop type if exists t_ddl_package_0069_01 cascade;
create type t_ddl_package_0069_01 as (
 RET_CODE varchar2 (6 ),
 RET_MSG varchar2 (512 ));

--step2:删除type expect:成功
drop type if exists t_ddl_package_0069_02 cascade;

--step3:创建domain expect:成功
create domain t_ddl_package_0069_02 as t_ddl_package_0069_01[];

--step4:创建函数 expect:成功
create or replace function f_ddl_package_0069 (RET t_ddl_package_0069_02)
returns t_ddl_package_0069_02
as $$
begin
    return t_ddl_package_0069_02;
end;
$$ language plpgsql;
/

--step5:清理环境 expect:成功
drop type t_ddl_package_0069_01 cascade;